Create Dimensions and Facts tables in OLAP Database and Populate Dimensions and Facts Tables 10
Run Script that is attached to create your Dictionary tables in the ODS Database. Once ran, the tables will be made up of these columns.
Dim_Tables
Stored Procedures
Dim_BorrowerDetails
Dim_BankDetails
Dim_BusinessDetails
Repeat the same Process for all the Dim Tables.
Completed SSIS Package
Results In SSMS
Fact Tables
Fact Table SSIS PACKAGES
Referential Integrity